package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class VippointlistExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public VippointlistExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBillmodeIsNull() {
            addCriterion("BillMode is null");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNotNull() {
            addCriterion("BillMode is not null");
            return (Criteria) this;
        }

        public Criteria andBillmodeEqualTo(String value) {
            addCriterion("BillMode =", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotEqualTo(String value) {
            addCriterion("BillMode <>", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThan(String value) {
            addCriterion("BillMode >", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThanOrEqualTo(String value) {
            addCriterion("BillMode >=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThan(String value) {
            addCriterion("BillMode <", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThanOrEqualTo(String value) {
            addCriterion("BillMode <=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLike(String value) {
            addCriterion("BillMode like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotLike(String value) {
            addCriterion("BillMode not like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIn(List<String> values) {
            addCriterion("BillMode in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotIn(List<String> values) {
            addCriterion("BillMode not in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeBetween(String value1, String value2) {
            addCriterion("BillMode between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotBetween(String value1, String value2) {
            addCriterion("BillMode not between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andPointsdateIsNull() {
            addCriterion("PointsDate is null");
            return (Criteria) this;
        }

        public Criteria andPointsdateIsNotNull() {
            addCriterion("PointsDate is not null");
            return (Criteria) this;
        }

        public Criteria andPointsdateEqualTo(Date value) {
            addCriterion("PointsDate =", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateNotEqualTo(Date value) {
            addCriterion("PointsDate <>", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateGreaterThan(Date value) {
            addCriterion("PointsDate >", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateGreaterThanOrEqualTo(Date value) {
            addCriterion("PointsDate >=", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateLessThan(Date value) {
            addCriterion("PointsDate <", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateLessThanOrEqualTo(Date value) {
            addCriterion("PointsDate <=", value, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateIn(List<Date> values) {
            addCriterion("PointsDate in", values, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateNotIn(List<Date> values) {
            addCriterion("PointsDate not in", values, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateBetween(Date value1, Date value2) {
            addCriterion("PointsDate between", value1, value2, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andPointsdateNotBetween(Date value1, Date value2) {
            addCriterion("PointsDate not between", value1, value2, "pointsdate");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andBilldateIsNull() {
            addCriterion("BillDate is null");
            return (Criteria) this;
        }

        public Criteria andBilldateIsNotNull() {
            addCriterion("BillDate is not null");
            return (Criteria) this;
        }

        public Criteria andBilldateEqualTo(Date value) {
            addCriterion("BillDate =", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotEqualTo(Date value) {
            addCriterion("BillDate <>", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThan(Date value) {
            addCriterion("BillDate >", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThanOrEqualTo(Date value) {
            addCriterion("BillDate >=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThan(Date value) {
            addCriterion("BillDate <", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThanOrEqualTo(Date value) {
            addCriterion("BillDate <=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateIn(List<Date> values) {
            addCriterion("BillDate in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotIn(List<Date> values) {
            addCriterion("BillDate not in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateBetween(Date value1, Date value2) {
            addCriterion("BillDate between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotBetween(Date value1, Date value2) {
            addCriterion("BillDate not between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andPointsIsNull() {
            addCriterion("Points is null");
            return (Criteria) this;
        }

        public Criteria andPointsIsNotNull() {
            addCriterion("Points is not null");
            return (Criteria) this;
        }

        public Criteria andPointsEqualTo(BigDecimal value) {
            addCriterion("Points =", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotEqualTo(BigDecimal value) {
            addCriterion("Points <>", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsGreaterThan(BigDecimal value) {
            addCriterion("Points >", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Points >=", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsLessThan(BigDecimal value) {
            addCriterion("Points <", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Points <=", value, "points");
            return (Criteria) this;
        }

        public Criteria andPointsIn(List<BigDecimal> values) {
            addCriterion("Points in", values, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotIn(List<BigDecimal> values) {
            addCriterion("Points not in", values, "points");
            return (Criteria) this;
        }

        public Criteria andPointsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Points between", value1, value2, "points");
            return (Criteria) this;
        }

        public Criteria andPointsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Points not between", value1, value2, "points");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtIsNull() {
            addCriterion("AdditiveAmt is null");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtIsNotNull() {
            addCriterion("AdditiveAmt is not null");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtEqualTo(BigDecimal value) {
            addCriterion("AdditiveAmt =", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtNotEqualTo(BigDecimal value) {
            addCriterion("AdditiveAmt <>", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtGreaterThan(BigDecimal value) {
            addCriterion("AdditiveAmt >", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AdditiveAmt >=", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtLessThan(BigDecimal value) {
            addCriterion("AdditiveAmt <", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AdditiveAmt <=", value, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtIn(List<BigDecimal> values) {
            addCriterion("AdditiveAmt in", values, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtNotIn(List<BigDecimal> values) {
            addCriterion("AdditiveAmt not in", values, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdditiveAmt between", value1, value2, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andAdditiveamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AdditiveAmt not between", value1, value2, "additiveamt");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("Operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("Operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(String value) {
            addCriterion("Operator =", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotEqualTo(String value) {
            addCriterion("Operator <>", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThan(String value) {
            addCriterion("Operator >", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThanOrEqualTo(String value) {
            addCriterion("Operator >=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThan(String value) {
            addCriterion("Operator <", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThanOrEqualTo(String value) {
            addCriterion("Operator <=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLike(String value) {
            addCriterion("Operator like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotLike(String value) {
            addCriterion("Operator not like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorIn(List<String> values) {
            addCriterion("Operator in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotIn(List<String> values) {
            addCriterion("Operator not in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorBetween(String value1, String value2) {
            addCriterion("Operator between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotBetween(String value1, String value2) {
            addCriterion("Operator not between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andBonusIsNull() {
            addCriterion("Bonus is null");
            return (Criteria) this;
        }

        public Criteria andBonusIsNotNull() {
            addCriterion("Bonus is not null");
            return (Criteria) this;
        }

        public Criteria andBonusEqualTo(BigDecimal value) {
            addCriterion("Bonus =", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotEqualTo(BigDecimal value) {
            addCriterion("Bonus <>", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThan(BigDecimal value) {
            addCriterion("Bonus >", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Bonus >=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThan(BigDecimal value) {
            addCriterion("Bonus <", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Bonus <=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusIn(List<BigDecimal> values) {
            addCriterion("Bonus in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotIn(List<BigDecimal> values) {
            addCriterion("Bonus not in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Bonus between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Bonus not between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIsNull() {
            addCriterion("NewCardNo is null");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIsNotNull() {
            addCriterion("NewCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andNewcardnoEqualTo(String value) {
            addCriterion("NewCardNo =", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotEqualTo(String value) {
            addCriterion("NewCardNo <>", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoGreaterThan(String value) {
            addCriterion("NewCardNo >", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("NewCardNo >=", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLessThan(String value) {
            addCriterion("NewCardNo <", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLessThanOrEqualTo(String value) {
            addCriterion("NewCardNo <=", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoLike(String value) {
            addCriterion("NewCardNo like", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotLike(String value) {
            addCriterion("NewCardNo not like", value, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoIn(List<String> values) {
            addCriterion("NewCardNo in", values, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotIn(List<String> values) {
            addCriterion("NewCardNo not in", values, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoBetween(String value1, String value2) {
            addCriterion("NewCardNo between", value1, value2, "newcardno");
            return (Criteria) this;
        }

        public Criteria andNewcardnoNotBetween(String value1, String value2) {
            addCriterion("NewCardNo not between", value1, value2, "newcardno");
            return (Criteria) this;
        }

        public Criteria andPointindateIsNull() {
            addCriterion("PointIndate is null");
            return (Criteria) this;
        }

        public Criteria andPointindateIsNotNull() {
            addCriterion("PointIndate is not null");
            return (Criteria) this;
        }

        public Criteria andPointindateEqualTo(Date value) {
            addCriterion("PointIndate =", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateNotEqualTo(Date value) {
            addCriterion("PointIndate <>", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateGreaterThan(Date value) {
            addCriterion("PointIndate >", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateGreaterThanOrEqualTo(Date value) {
            addCriterion("PointIndate >=", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateLessThan(Date value) {
            addCriterion("PointIndate <", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateLessThanOrEqualTo(Date value) {
            addCriterion("PointIndate <=", value, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateIn(List<Date> values) {
            addCriterion("PointIndate in", values, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateNotIn(List<Date> values) {
            addCriterion("PointIndate not in", values, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateBetween(Date value1, Date value2) {
            addCriterion("PointIndate between", value1, value2, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPointindateNotBetween(Date value1, Date value2) {
            addCriterion("PointIndate not between", value1, value2, "pointindate");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusIsNull() {
            addCriterion("Point2Bonus is null");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusIsNotNull() {
            addCriterion("Point2Bonus is not null");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusEqualTo(BigDecimal value) {
            addCriterion("Point2Bonus =", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusNotEqualTo(BigDecimal value) {
            addCriterion("Point2Bonus <>", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusGreaterThan(BigDecimal value) {
            addCriterion("Point2Bonus >", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Point2Bonus >=", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusLessThan(BigDecimal value) {
            addCriterion("Point2Bonus <", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Point2Bonus <=", value, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusIn(List<BigDecimal> values) {
            addCriterion("Point2Bonus in", values, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusNotIn(List<BigDecimal> values) {
            addCriterion("Point2Bonus not in", values, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Point2Bonus between", value1, value2, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2bonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Point2Bonus not between", value1, value2, "point2bonus");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelIsNull() {
            addCriterion("Point2Cancel is null");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelIsNotNull() {
            addCriterion("Point2Cancel is not null");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelEqualTo(BigDecimal value) {
            addCriterion("Point2Cancel =", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelNotEqualTo(BigDecimal value) {
            addCriterion("Point2Cancel <>", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelGreaterThan(BigDecimal value) {
            addCriterion("Point2Cancel >", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Point2Cancel >=", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelLessThan(BigDecimal value) {
            addCriterion("Point2Cancel <", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Point2Cancel <=", value, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelIn(List<BigDecimal> values) {
            addCriterion("Point2Cancel in", values, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelNotIn(List<BigDecimal> values) {
            addCriterion("Point2Cancel not in", values, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Point2Cancel between", value1, value2, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andPoint2cancelNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Point2Cancel not between", value1, value2, "point2cancel");
            return (Criteria) this;
        }

        public Criteria andCancelreasonIsNull() {
            addCriterion("CancelReason is null");
            return (Criteria) this;
        }

        public Criteria andCancelreasonIsNotNull() {
            addCriterion("CancelReason is not null");
            return (Criteria) this;
        }

        public Criteria andCancelreasonEqualTo(String value) {
            addCriterion("CancelReason =", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonNotEqualTo(String value) {
            addCriterion("CancelReason <>", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonGreaterThan(String value) {
            addCriterion("CancelReason >", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonGreaterThanOrEqualTo(String value) {
            addCriterion("CancelReason >=", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonLessThan(String value) {
            addCriterion("CancelReason <", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonLessThanOrEqualTo(String value) {
            addCriterion("CancelReason <=", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonLike(String value) {
            addCriterion("CancelReason like", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonNotLike(String value) {
            addCriterion("CancelReason not like", value, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonIn(List<String> values) {
            addCriterion("CancelReason in", values, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonNotIn(List<String> values) {
            addCriterion("CancelReason not in", values, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonBetween(String value1, String value2) {
            addCriterion("CancelReason between", value1, value2, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCancelreasonNotBetween(String value1, String value2) {
            addCriterion("CancelReason not between", value1, value2, "cancelreason");
            return (Criteria) this;
        }

        public Criteria andCanceldateIsNull() {
            addCriterion("CancelDate is null");
            return (Criteria) this;
        }

        public Criteria andCanceldateIsNotNull() {
            addCriterion("CancelDate is not null");
            return (Criteria) this;
        }

        public Criteria andCanceldateEqualTo(Date value) {
            addCriterion("CancelDate =", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotEqualTo(Date value) {
            addCriterion("CancelDate <>", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateGreaterThan(Date value) {
            addCriterion("CancelDate >", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateGreaterThanOrEqualTo(Date value) {
            addCriterion("CancelDate >=", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateLessThan(Date value) {
            addCriterion("CancelDate <", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateLessThanOrEqualTo(Date value) {
            addCriterion("CancelDate <=", value, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateIn(List<Date> values) {
            addCriterion("CancelDate in", values, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotIn(List<Date> values) {
            addCriterion("CancelDate not in", values, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateBetween(Date value1, Date value2) {
            addCriterion("CancelDate between", value1, value2, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceldateNotBetween(Date value1, Date value2) {
            addCriterion("CancelDate not between", value1, value2, "canceldate");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorIsNull() {
            addCriterion("CancelOperator is null");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorIsNotNull() {
            addCriterion("CancelOperator is not null");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorEqualTo(String value) {
            addCriterion("CancelOperator =", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorNotEqualTo(String value) {
            addCriterion("CancelOperator <>", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorGreaterThan(String value) {
            addCriterion("CancelOperator >", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorGreaterThanOrEqualTo(String value) {
            addCriterion("CancelOperator >=", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorLessThan(String value) {
            addCriterion("CancelOperator <", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorLessThanOrEqualTo(String value) {
            addCriterion("CancelOperator <=", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorLike(String value) {
            addCriterion("CancelOperator like", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorNotLike(String value) {
            addCriterion("CancelOperator not like", value, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorIn(List<String> values) {
            addCriterion("CancelOperator in", values, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorNotIn(List<String> values) {
            addCriterion("CancelOperator not in", values, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorBetween(String value1, String value2) {
            addCriterion("CancelOperator between", value1, value2, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andCanceloperatorNotBetween(String value1, String value2) {
            addCriterion("CancelOperator not between", value1, value2, "canceloperator");
            return (Criteria) this;
        }

        public Criteria andListnoIsNull() {
            addCriterion("ListNo is null");
            return (Criteria) this;
        }

        public Criteria andListnoIsNotNull() {
            addCriterion("ListNo is not null");
            return (Criteria) this;
        }

        public Criteria andListnoEqualTo(Long value) {
            addCriterion("ListNo =", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoNotEqualTo(Long value) {
            addCriterion("ListNo <>", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoGreaterThan(Long value) {
            addCriterion("ListNo >", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoGreaterThanOrEqualTo(Long value) {
            addCriterion("ListNo >=", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoLessThan(Long value) {
            addCriterion("ListNo <", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoLessThanOrEqualTo(Long value) {
            addCriterion("ListNo <=", value, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoIn(List<Long> values) {
            addCriterion("ListNo in", values, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoNotIn(List<Long> values) {
            addCriterion("ListNo not in", values, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoBetween(Long value1, Long value2) {
            addCriterion("ListNo between", value1, value2, "listno");
            return (Criteria) this;
        }

        public Criteria andListnoNotBetween(Long value1, Long value2) {
            addCriterion("ListNo not between", value1, value2, "listno");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andBillamtIsNull() {
            addCriterion("BillAmt is null");
            return (Criteria) this;
        }

        public Criteria andBillamtIsNotNull() {
            addCriterion("BillAmt is not null");
            return (Criteria) this;
        }

        public Criteria andBillamtEqualTo(BigDecimal value) {
            addCriterion("BillAmt =", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotEqualTo(BigDecimal value) {
            addCriterion("BillAmt <>", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtGreaterThan(BigDecimal value) {
            addCriterion("BillAmt >", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("BillAmt >=", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtLessThan(BigDecimal value) {
            addCriterion("BillAmt <", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("BillAmt <=", value, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtIn(List<BigDecimal> values) {
            addCriterion("BillAmt in", values, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotIn(List<BigDecimal> values) {
            addCriterion("BillAmt not in", values, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BillAmt between", value1, value2, "billamt");
            return (Criteria) this;
        }

        public Criteria andBillamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("BillAmt not between", value1, value2, "billamt");
            return (Criteria) this;
        }

        public Criteria andBilllistIsNull() {
            addCriterion("BillList is null");
            return (Criteria) this;
        }

        public Criteria andBilllistIsNotNull() {
            addCriterion("BillList is not null");
            return (Criteria) this;
        }

        public Criteria andBilllistEqualTo(Long value) {
            addCriterion("BillList =", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotEqualTo(Long value) {
            addCriterion("BillList <>", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistGreaterThan(Long value) {
            addCriterion("BillList >", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistGreaterThanOrEqualTo(Long value) {
            addCriterion("BillList >=", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistLessThan(Long value) {
            addCriterion("BillList <", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistLessThanOrEqualTo(Long value) {
            addCriterion("BillList <=", value, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistIn(List<Long> values) {
            addCriterion("BillList in", values, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotIn(List<Long> values) {
            addCriterion("BillList not in", values, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistBetween(Long value1, Long value2) {
            addCriterion("BillList between", value1, value2, "billlist");
            return (Criteria) this;
        }

        public Criteria andBilllistNotBetween(Long value1, Long value2) {
            addCriterion("BillList not between", value1, value2, "billlist");
            return (Criteria) this;
        }

        public Criteria andPointstartIsNull() {
            addCriterion("PointStart is null");
            return (Criteria) this;
        }

        public Criteria andPointstartIsNotNull() {
            addCriterion("PointStart is not null");
            return (Criteria) this;
        }

        public Criteria andPointstartEqualTo(Date value) {
            addCriterion("PointStart =", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartNotEqualTo(Date value) {
            addCriterion("PointStart <>", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartGreaterThan(Date value) {
            addCriterion("PointStart >", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartGreaterThanOrEqualTo(Date value) {
            addCriterion("PointStart >=", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartLessThan(Date value) {
            addCriterion("PointStart <", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartLessThanOrEqualTo(Date value) {
            addCriterion("PointStart <=", value, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartIn(List<Date> values) {
            addCriterion("PointStart in", values, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartNotIn(List<Date> values) {
            addCriterion("PointStart not in", values, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartBetween(Date value1, Date value2) {
            addCriterion("PointStart between", value1, value2, "pointstart");
            return (Criteria) this;
        }

        public Criteria andPointstartNotBetween(Date value1, Date value2) {
            addCriterion("PointStart not between", value1, value2, "pointstart");
            return (Criteria) this;
        }

        public Criteria andThawflagIsNull() {
            addCriterion("ThawFlag is null");
            return (Criteria) this;
        }

        public Criteria andThawflagIsNotNull() {
            addCriterion("ThawFlag is not null");
            return (Criteria) this;
        }

        public Criteria andThawflagEqualTo(String value) {
            addCriterion("ThawFlag =", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagNotEqualTo(String value) {
            addCriterion("ThawFlag <>", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagGreaterThan(String value) {
            addCriterion("ThawFlag >", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagGreaterThanOrEqualTo(String value) {
            addCriterion("ThawFlag >=", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagLessThan(String value) {
            addCriterion("ThawFlag <", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagLessThanOrEqualTo(String value) {
            addCriterion("ThawFlag <=", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagLike(String value) {
            addCriterion("ThawFlag like", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagNotLike(String value) {
            addCriterion("ThawFlag not like", value, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagIn(List<String> values) {
            addCriterion("ThawFlag in", values, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagNotIn(List<String> values) {
            addCriterion("ThawFlag not in", values, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagBetween(String value1, String value2) {
            addCriterion("ThawFlag between", value1, value2, "thawflag");
            return (Criteria) this;
        }

        public Criteria andThawflagNotBetween(String value1, String value2) {
            addCriterion("ThawFlag not between", value1, value2, "thawflag");
            return (Criteria) this;
        }

        public Criteria andFreezeamtIsNull() {
            addCriterion("FreezeAmt is null");
            return (Criteria) this;
        }

        public Criteria andFreezeamtIsNotNull() {
            addCriterion("FreezeAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFreezeamtEqualTo(BigDecimal value) {
            addCriterion("FreezeAmt =", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtNotEqualTo(BigDecimal value) {
            addCriterion("FreezeAmt <>", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtGreaterThan(BigDecimal value) {
            addCriterion("FreezeAmt >", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FreezeAmt >=", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtLessThan(BigDecimal value) {
            addCriterion("FreezeAmt <", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FreezeAmt <=", value, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtIn(List<BigDecimal> values) {
            addCriterion("FreezeAmt in", values, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtNotIn(List<BigDecimal> values) {
            addCriterion("FreezeAmt not in", values, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FreezeAmt between", value1, value2, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andFreezeamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FreezeAmt not between", value1, value2, "freezeamt");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNull() {
            addCriterion("BankType is null");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNotNull() {
            addCriterion("BankType is not null");
            return (Criteria) this;
        }

        public Criteria andBanktypeEqualTo(String value) {
            addCriterion("BankType =", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotEqualTo(String value) {
            addCriterion("BankType <>", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThan(String value) {
            addCriterion("BankType >", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThanOrEqualTo(String value) {
            addCriterion("BankType >=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThan(String value) {
            addCriterion("BankType <", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThanOrEqualTo(String value) {
            addCriterion("BankType <=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLike(String value) {
            addCriterion("BankType like", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotLike(String value) {
            addCriterion("BankType not like", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeIn(List<String> values) {
            addCriterion("BankType in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotIn(List<String> values) {
            addCriterion("BankType not in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeBetween(String value1, String value2) {
            addCriterion("BankType between", value1, value2, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotBetween(String value1, String value2) {
            addCriterion("BankType not between", value1, value2, "banktype");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}